2016-05-20 - 26937.300 - Break Fix - Sales Portal Phase II #CrystalReportsSupport

Break Fix

26937.300 - Sales Portal Phase II

Problem Summary

---

Need to include customers in the ZSD_SHIP_Q001 BEx Query for SH900 report for sales portal tracking.

Admin Info

---

Purpose	Need to add customers to ZSD_SHIP_Q001 BEx Query
Requested by	Randy Benjamin
Issue Date	05-19-2016
Resolved by	Naveen Gadde
Resolved Date	05-20-2016
Document Status	Complete

Detailed Problem Description

---

Email from Bibin Mohan on 05/21/2016:
BEx Query ZSD_SHIP_Q001 is restricted to show data only for the following customers, as they were hard coded at the BEx side, SH900 report doesn't show data for the requested Customers:
1004821
1005775
1004795
1005293
1005331
1012914
1013842
1012965
1012129
1010842
1014887
1017775

Email from Bibin on 06/03/2016:
Here is a change we need to make. Right now, we have the customer numbers hard coded in the query. Instead, use the following query to pull up the active account numbers directly from db
select distinct customernumber from [CustomerPortal].[dbo].[ApplicationUsers] (nolock) where active=1.

IM from Saravanan on 06/23/2016:
Now the sales portal team wants to see historical data. We need to change the filter from 90 to 365. But not in current calendar year..it has to be rolling.

Solution Analysis and Recommendations

---

Solution for the issue on 05/21/2016:
Update the BEx Query to show data for following customers apart from the above customers as requested:
1004876
1005141
1005276
1005556
1005580
1005600
1005644
1006588
1006833
1007002
1007248
1007824
1007839
1007910
1008237
1012552
1012913
1012955

Solution for the issue on 06/03/2016:
Remove the customer filter from BEx Query & join the BEx Query with the Customer Portal server as per the logic provided.

Solution for the issue on 06/23/2016:
Change the BEx query filter to 365 days instead of 90 days.

Resolution

---

SH900 report will show data for all customers that are requested for the historical 365 days now.

Release Information

---

2016-05-20 - 26937.300 - Rel Notes - Sales Portal Phase II - Release 001
2016-06-07 - 26937.300 - Rel Notes - Sales Portal Phase II - Release 002
2016-06-10 - 26937.300 - Rel Notes - Sales Portal Phase II - Release 003